SHOW FULL COLUMNS FROM `mtr_bus_route` [ RunTime:0.000648s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-520-O-0' LIMIT 1 [ RunTime:0.000223s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-520-O-0' LIMIT 1 [ RunTime:0.000242s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-520-I-0' LIMIT 1 [ RunTime:0.000266s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-520-I-0' LIMIT 1 [ RunTime:0.000200s ]
SHOW FULL COLUMNS FROM `mtr_bus_stop` [ RunTime:0.000444s ]
SELECT `id`,`name` FROM `mtr_bus_stop` WHERE `id` IN ('RMB-18095','RMB-18098','RMB-18099','RMB-18100','RMB-18101','RMB-18103','RMB-18104','RMB-18105','RMB-18106','RMB-18109') [ RunTime:0.000295s ]
SELECT `id`,`no`,`co`,`name`,`stop_list`,`orig`,`dest` FROM `mtr_bus_route` `r` WHERE `r`.`bound` = 'O' AND ( JSON_CONTAINS(stop_list, '"RMB-18095"') ) LIMIT 10 [ RunTime:0.104489s ]